Stores the physical data definition of the property. Property definitions are initially defined from SQL and can be refreshed from the database at any time.
By default, the BOD Definition sub-tab is found in the following location:
■ Tools > Business object designer, then from the toolbar choose New > Design Business Definition (or select an existing object, then from the toolbar choose Edit), then select the Properties tab.
Caution! Do not use SQL Server reserved keywords as table or column names.
Stored in Database?
Indicates whether the field is stored in the database. Option is disabled and always set to Yes.
Database Table
The drop-down contains any tables used in defining the object with the default being the table name that matches the object’s name, if any.
Database Column
Defaults to PropertyName (from the Property List) if creating by adding properties. PropertyName from the PropertyList defaults to this value if reverse engineering existing tables (like what is done today)
Allows NULL?
Allows a null value to be entered for the property when it's saved. When cleared, data must be entered for the property before it can be saved. This value is inherited from the database, but it can be manually changed here.
References Object
Indicates the business object for which this property is a foreign key.
Identity Column?
Indicates whether the column auto-increments. If enabled, uses the following:
■ Start Value - This is the initial or “seed” value (integer) of the identity. The default is 1.
■ Increment - This is an integer by which the identity is incremented with each new row. The default is 1.
Calculated Value
Unused.
Read Only?
If checked, the property’s value cannot be modified. Read Only is automatically checked and cannot be changed if there is an expression for Calculated Value.
System Property? (Internal Use Only)
Identifies a property as system defined. When selected, the property can only be modified by an administrator.
Log All Changes?
If checked, any changes made to the value stored in this property is logged to the change log.
Query Builder
Enable these options to expose the property for use in queries.
■ Available to Query Builder? – Makes the property available for use in IQA whenever the business object is selected as a source.
■ Automatically Include in Queries? – Automatically includes the property in an IQA query result set whenever the business object is selected as a source.
Security
Unused.
Description
A free-form text description for the property. The description is available as a tool tip in the Screen Designer.